Crate google_sheets4

source ·
Expand description

This documentation was generated from Sheets crate version 5.0.5+20240621, where 20240621 is the exact revision of the sheets:v4 schema built by the mako code generator v5.0.5.

Everything else about the Sheets v4 API can be found at the official documentation site. The original source code is on github.

§Features

Handle the following Resources with ease from the central hub

Not what you are looking for ? Find all other Google APIs in their Rust documentation index.

§Structure of this Library

The API is structured into the following primary items:

  • Hub
    • a central object to maintain state and allow accessing all Activities
    • creates Method Builders which in turn allow access to individual Call Builders
  • Resources
    • primary types that you can apply Activities to
    • a collection of properties and Parts
    • Parts
      • a collection of properties
      • never directly used in Activities
  • Activities
    • operations to apply to Resources

All structures are marked with applicable traits to further categorize them and ease browsing.

Generally speaking, you can invoke Activities like this:

let r = hub.resource().activity(...).doit().await

Or specifically …

let r = hub.spreadsheets().developer_metadata_get(...).doit().await
let r = hub.spreadsheets().developer_metadata_search(...).doit().await
let r = hub.spreadsheets().sheets_copy_to(...).doit().await
let r = hub.spreadsheets().values_append(...).doit().await
let r = hub.spreadsheets().values_batch_clear(...).doit().await
let r = hub.spreadsheets().values_batch_clear_by_data_filter(...).doit().await
let r = hub.spreadsheets().values_batch_get(...).doit().await
let r = hub.spreadsheets().values_batch_get_by_data_filter(...).doit().await
let r = hub.spreadsheets().values_batch_update(...).doit().await
let r = hub.spreadsheets().values_batch_update_by_data_filter(...).doit().await
let r = hub.spreadsheets().values_clear(...).doit().await
let r = hub.spreadsheets().values_get(...).doit().await
let r = hub.spreadsheets().values_update(...).doit().await
let r = hub.spreadsheets().batch_update(...).doit().await
let r = hub.spreadsheets().create(...).doit().await
let r = hub.spreadsheets().get(...).doit().await
let r = hub.spreadsheets().get_by_data_filter(...).doit().await

The resource() and activity(...) calls create builders. The second one dealing with Activities supports various methods to configure the impending operation (not shown here). It is made such that all required arguments have to be specified right away (i.e. (...)), whereas all optional ones can be build up as desired. The doit() method performs the actual communication with the server and returns the respective result.

§Usage

§Setting up your Project

To use this library, you would put the following lines into your Cargo.toml file:

[dependencies]
google-sheets4 = "*"
serde = "^1.0"
serde_json = "^1.0"

§A complete example

extern crate hyper;
extern crate hyper_rustls;
extern crate google_sheets4 as sheets4;
use sheets4::api::ValueRange;
use sheets4::{Result, Error};
use std::default::Default;
use sheets4::{Sheets, oauth2, hyper, hyper_rustls, chrono, FieldMask};
 
// Get an ApplicationSecret instance by some means. It contains the `client_id` and 
// `client_secret`, among other things.
let secret: oauth2::ApplicationSecret = Default::default();
// Instantiate the authenticator. It will choose a suitable authentication flow for you, 
// unless you replace  `None` with the desired Flow.
// Provide your own `AuthenticatorDelegate` to adjust the way it operates and get feedback about 
// what's going on. You probably want to bring in your own `TokenStorage` to persist tokens and
// retrieve them from storage.
let auth = oauth2::InstalledFlowAuthenticator::builder(
        secret,
        oauth2::InstalledFlowReturnMethod::HTTPRedirect,
    ).build().await.unwrap();
let mut hub = Sheets::new(hyper::Client::builder().build(hyper_rustls::HttpsConnectorBuilder::new().with_native_roots().unwrap().https_or_http().enable_http1().build()), auth);
// As the method needs a request, you would usually fill it with the desired information
// into the respective structure. Some of the parts shown here might not be applicable !
// Values shown here are possibly random and not representative !
let mut req = ValueRange::default();
 
// You can configure optional parameters by calling the respective setters at will, and
// execute the final call using `doit()`.
// Values shown here are possibly random and not representative !
let result = hub.spreadsheets().values_append(req, "spreadsheetId", "range")
             .value_input_option("amet.")
             .response_value_render_option("duo")
             .response_date_time_render_option("ipsum")
             .insert_data_option("gubergren")
             .include_values_in_response(true)
             .doit().await;
 
match result {
    Err(e) => match e {
        // The Error enum provides details about what exactly happened.
        // You can also just use its `Debug`, `Display` or `Error` traits
         Error::HttpError(_)
        |Error::Io(_)
        |Error::MissingAPIKey
        |Error::MissingToken(_)
        |Error::Cancelled
        |Error::UploadSizeLimitExceeded(_, _)
        |Error::Failure(_)
        |Error::BadRequest(_)
        |Error::FieldClash(_)
        |Error::JsonDecodeError(_, _) => println!("{}", e),
    },
    Ok(res) => println!("Success: {:?}", res),
}

§Handling Errors

All errors produced by the system are provided either as Result enumeration as return value of the doit() methods, or handed as possibly intermediate results to either the Hub Delegate, or the Authenticator Delegate.

When delegates handle errors or intermediate values, they may have a chance to instruct the system to retry. This makes the system potentially resilient to all kinds of errors.

§Uploads and Downloads

If a method supports downloads, the response body, which is part of the Result, should be read by you to obtain the media. If such a method also supports a Response Result, it will return that by default. You can see it as meta-data for the actual media. To trigger a media download, you will have to set up the builder by making this call: .param("alt", "media").

Methods supporting uploads can do so using up to 2 different protocols: simple and resumable. The distinctiveness of each is represented by customized doit(...) methods, which are then named upload(...) and upload_resumable(...) respectively.

§Customization and Callbacks

You may alter the way an doit() method is called by providing a delegate to the Method Builder before making the final doit() call. Respective methods will be called to provide progress information, as well as determine whether the system should retry on failure.

The delegate trait is default-implemented, allowing you to customize it with minimal effort.

§Optional Parts in Server-Requests

All structures provided by this library are made to be encodable and decodable via json. Optionals are used to indicate that partial requests are responses are valid. Most optionals are are considered Parts which are identifiable by name, which will be sent to the server to indicate either the set parts of the request or the desired parts in the response.

§Builder Arguments

Using method builders, you are able to prepare an action call by repeatedly calling it’s methods. These will always take a single argument, for which the following statements are true.

Arguments will always be copied or cloned into the builder, to make them independent of their original life times.

§Cargo Features

  • utoipa - Add support for utoipa and derive utoipa::ToSchema on all the types. You’ll have to import and register the required types in #[openapi(schemas(...))], otherwise the generated openapi spec would be invalid.

Re-exports§

Modules§

Structs§

  • A FieldMask as defined in https://github.com/protocolbuffers/protobuf/blob/ec1a70913e5793a7d0a7b5fbf7e0e4f75409dd41/src/google/protobuf/field_mask.proto#L180

Enums§

Traits§

  • A trait specifying functionality to help controlling any request performed by the API. The trait has a conservative default implementation.

Type Aliases§

  • A universal result type used as return for all calls.